package com.liu.dao;

import com.liu.dto.DepartmentCountDto;
import com.liu.entity.Department;

import java.util.List;

public interface DepartmentDao {
    //新增
    int add(Department department);
    //查询
    List<Department> selectAll();
    //删除
    int del(int id);
    //修改
    int update(Department department);
    //查询，带条件 动态sql
    List<Department> selectWhere(String dptname);
    //批量删除
    int delBatch(int[] ids);

    List<DepartmentCountDto> selectCount();
    List<DepartmentCountDto> selectCountByName(String dptname);
}
